Mybatis
- MyBatis는 개발자가 지정한 SQL 저장 프로시저나 매핑을 지원하는 퍼시스턴스 프레임워크
모든 MyBatis는 SqlSessionFactory인스턴스를 사용한다.
1) 숨긴정보
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssafyweb?serverTimezone=UTC&useUniCode=yes&characterEncoding=UTF-8
username=ssafy
password=ssafy1) sql 쿼리 정보
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ssafy.mybatis.dao.MemberDao">
<resultMap type="memberDto" id="member">
<result column="user_id" property="userId"/>
<result column="user_name" property="userName"/>
<result column="user_password" property="userPwd"/>
<result column="email_id" property="emailId"/>
<result column="email_domain" property="emailDomain"/>
<result column="join_date" property="joinDate"/>
</resultMap>
<insert id="joinMember" parameterType="memberDto">
insert into members (user_name, user_id, user_password, email_id, email_domain, join_date)
values (#{userName}, #{userId}, #{userPwd}, #{emailId}, #{emailDomain}, now())
</insert>
<select id="listMember" resultMap="member">
select user_id, user_name, user_password, email_id, email_domain, join_date
from members
</select>
</mapper>2) mybatis 환경정보
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<properties resource="com/ssafy/mybatis/config/dbinfo.properties"/>
<typeAliases>
<typeAlias type="com.ssafy.mybatis.MemberDto" alias="memberDto" />
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC" />
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/ssafy/mybatis/config/member.xml" />
</mappers>
</configuration>3) mybatis 팩토리
package com.ssafy.mybatis.config;
import java.io.IOException;
import java.io.Reader;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
public class SqlMapConfig {
private static SqlSessionFactory sqlSessionFactory;
static {
try {
String resource = "com/ssafy/mybatis/config/mybatis-config.xml";
Reader reader = Resources.getResourceAsReader(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getSqlSession() {
return sqlSessionFactory.openSession();
}
}